home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
cashbox.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
920b
|
23 lines
/* RCSVER $Id: cashbox.sql,v 1.1 1999-02-25 15:10:52-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: cashbox.sql
* Date: 02/23/1999
* memo: Randy Wood
* Description: Create the cashbox table. Cashbox contains an entry
* for each cashbox active in the system.
* Changes:
************************************************************************* */
CREATE TABLE cashbox
(
cashbox_glid NUMBER(38) /* Internal sw ID for cashbox */
CONSTRAINT ref_cashbox1 REFERENCES global_id(glid)
ON DELETE CASCADE,
cb_sernum VARCHAR2(20), /* ser. num of electronic ID */
/* THIS VALUE IS USED AT THE FAREBOX */
/* >> not << THE GLOBAL ID */
status NUMBER(38), /* primary status: in service etc. */
CONSTRAINT pk_cashbox PRIMARY KEY (cashbox_glid)
);